UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmUPXWDJDkmEVBWCC+O9/lOhh1qzDMteLwpNMGBURrk='
WHERE
key_id = 'a18f6a8fee64325563a58726e22c739e5cfdb85a4ab745450733bedf8f3e835e'
AND (
token = 'xmUPXWDJDkmEVBWCC+O9/lOhh1qzDMteLwpNMGBURrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)