UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcIMYtzAFkzPQ9q6unSW8GnuED45Inh8QshhY327lrY='
WHERE
key_id = '76725c51913fa538dd4f07432e4e4e3a763958bddf4ad6e8384cb1ce224de018'
AND (
token = 'NcIMYtzAFkzPQ9q6unSW8GnuED45Inh8QshhY327lrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)