UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3BAlzztMdUoE5+xfnU9I1FDkKsdI0lYTTemhoehsScc='
WHERE
key_id = '8b74984d9e6b02951d87e34e231bc8f4682da85ccf3ea54f2c5af1217f652817'
AND (
token = '3BAlzztMdUoE5+xfnU9I1FDkKsdI0lYTTemhoehsScc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)