UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iCfVqrsKUzoYmVOaAjl7tnTNj02FpZvQAxh8vc5q8qk='
WHERE
key_id = '8a085bfcd80edbc70b2a45ea4b899abc5a9e1bbdfdf10dcc65abde710937ac7e'
AND (
token = 'iCfVqrsKUzoYmVOaAjl7tnTNj02FpZvQAxh8vc5q8qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)