UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KUNW1QEK3HJxigMkdxqWMBpIOl2BsIQzEEt5WZYmgw='
WHERE
key_id = '60135c5292f253f104d0d9e9abf45e5eb4253b8f825ded5c197aa7eb0216b548'
AND (
token = '/KUNW1QEK3HJxigMkdxqWMBpIOl2BsIQzEEt5WZYmgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)