UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KhApG39s7CpKuUoLnW3o9cSBBmFQ82a153XYMku5+4='
WHERE
key_id = 'cce9fd6f4069fa7bf1f7c97db6c6b5cf3441b2d02fda810b59ad7748b495aac8'
AND (
token = '4KhApG39s7CpKuUoLnW3o9cSBBmFQ82a153XYMku5+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)