UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gR6IKuvv0czIHCRpn5McryQiGM4lTQ8maIybfiascTI='
WHERE
key_id = '0516875d8b84c1abce00923a471420e2603570fc9da1c10f6d9164abd2de1eac'
AND (
token = 'gR6IKuvv0czIHCRpn5McryQiGM4lTQ8maIybfiascTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)