UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IV7/x1ojJ3lenu04G+F5zGnswSRg+M61EPncqD5XuDA='
WHERE
key_id = 'fa0dcf85b9b19ea09b02faa8a54a0a04abc9efb721ed495f9080021b2c30fe45'
AND (
token = 'IV7/x1ojJ3lenu04G+F5zGnswSRg+M61EPncqD5XuDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)