UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7GDjPyJjQcXuW4DbPtT73nX35O4Eq89o706oprBiQI='
WHERE
key_id = '3b7dce0fad4f9c52966f46ba5b88af2bb44a798cb44245eb3fe82b1a2e87b4cf'
AND (
token = 'w7GDjPyJjQcXuW4DbPtT73nX35O4Eq89o706oprBiQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)