UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idwc77jlKhE+QH34PkBzzNSj44b4jmKws4imp3KwwFg='
WHERE
key_id = 'b1288bad08e34d96cea01a552b725bfbac07f5e44ade13477a3f77cf39d2ef74'
AND (
token = 'idwc77jlKhE+QH34PkBzzNSj44b4jmKws4imp3KwwFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)