UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YI1H9IDTkOAS1yn7PadhAr+cUCUKZVAJfmXC4giguy4='
WHERE
key_id = '472deebe08325a04940d348c331c0f17490598964f7107cbb414c94712c84b5b'
AND (
token = 'YI1H9IDTkOAS1yn7PadhAr+cUCUKZVAJfmXC4giguy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)