UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h8ipIjjeU+Bw7sN0Hbxw8F0xC3AXvWOK8kZNFxNi1nU='
WHERE
key_id = 'b10ee564eb49e9d281a28a9575d866f78236aef77f055c55341a171705fa9334'
AND (
token = 'h8ipIjjeU+Bw7sN0Hbxw8F0xC3AXvWOK8kZNFxNi1nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)