UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ynsxs422yudqe8Ig9iwJdfu/MA/HKaO9WMq+clXf79A='
WHERE
key_id = 'bc1e6dfb9143a8ebd56152feaeaa71e8b551edf09e8190863881c024ce13693c'
AND (
token = 'ynsxs422yudqe8Ig9iwJdfu/MA/HKaO9WMq+clXf79A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)