UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apPp6FmjcXFJP2A+sKzSAqWTOxhP79KVDJ1yO1RXyQg='
WHERE
key_id = 'bf8e2e3180f3678c12c41f6b75342401c6aa4bd7c84dc29fee06edf3f77875c8'
AND (
token = 'apPp6FmjcXFJP2A+sKzSAqWTOxhP79KVDJ1yO1RXyQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)