UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CdXImv4nsJmy7jmmSV8hJ8rPGtaQHxc55BSa0ZNrt4k='
WHERE
key_id = '48281c75de8ee119639137ef37388fe4f238bbbabc5bdeeeb2ce777d27c8a5df'
AND (
token = 'CdXImv4nsJmy7jmmSV8hJ8rPGtaQHxc55BSa0ZNrt4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)