UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzdHLX1mttgvctre0T7L4FDkUKdOb5Y77tOzTWxLTHI='
WHERE
key_id = '367280a8bc88f872fceffc0b7a9d734bf4c3dfe3b48fba57f69dfb1163297178'
AND (
token = 'mzdHLX1mttgvctre0T7L4FDkUKdOb5Y77tOzTWxLTHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)