UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/cPbARqb4tMideRi+yT+X1Jxy4N/NuvUaKPzruG3xKk='
WHERE
key_id = 'b3d1d02387ada99ac10807be799a1c3032b7c4abcbec48ccdfd5304bd4ba3783'
AND (
token = '/cPbARqb4tMideRi+yT+X1Jxy4N/NuvUaKPzruG3xKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)