UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTNejMAENq3ajQaBtaHG9hy1sBD9BKovklZhUKpRB9I='
WHERE
key_id = '478f8bbe5bbb98851c9fa2bc2d428ccb6bc3766e02f7f98cd3de167dd5402240'
AND (
token = 'xTNejMAENq3ajQaBtaHG9hy1sBD9BKovklZhUKpRB9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)