UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SXCvPOs7tid0kPIprIDrUzKdKdkgn1JIulUs2oZnics='
WHERE
key_id = 'd2c46cf374b2950e0984967e1ce324819a96124de5bd6d4772de20966fa1b866'
AND (
token = 'SXCvPOs7tid0kPIprIDrUzKdKdkgn1JIulUs2oZnics='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)