UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TcXwpL0kAid8E3N/clScuj+m48Qw03wbq5I8ISIzes='
WHERE
key_id = '5fe1922cd640286cc5a77a5557be7724674a0bbb2402c6b7c0f1206508275a35'
AND (
token = '9TcXwpL0kAid8E3N/clScuj+m48Qw03wbq5I8ISIzes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)