UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e898JM+CwHymBwXH0mDrvukFNDOYo47iUghE3+jO7uE='
WHERE
key_id = 'a24b8c3d8030515577a8eca22d5cb44c7e1478257bc08a6070502d198150a85a'
AND (
token = 'e898JM+CwHymBwXH0mDrvukFNDOYo47iUghE3+jO7uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)