UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDsehmNQvzcqRJzLXBsFTVu534BoDACUQRxL9MNUCrM='
WHERE
key_id = '71c27b4974a709b5621e0c8878a6db7717350beb899446564b5b936e80fa7fa8'
AND (
token = 'sDsehmNQvzcqRJzLXBsFTVu534BoDACUQRxL9MNUCrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)