UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnxjH86MJ2KE+JxUDv3byPAEYau35XVVztY5Sh9d/Hg='
WHERE
key_id = '970258aa4b48b406592b645e0f4c264cf58843052b4cc455f1622cacced7ecf3'
AND (
token = 'pnxjH86MJ2KE+JxUDv3byPAEYau35XVVztY5Sh9d/Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)