UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZkopy3tnqfNEHvCN5PJyXiqUH7HZ9M5/V3DvZSPAEU='
WHERE
key_id = '9f89035b42728084d7cf7d887f9b6d47e1e6e022de8cd372df5249286c06fa1f'
AND (
token = 'MZkopy3tnqfNEHvCN5PJyXiqUH7HZ9M5/V3DvZSPAEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)