UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y5hu8YFk5K3HRYCQrf142J2p9Q3x+SNTpmjriafR+rk='
WHERE
key_id = 'e23d1c2c242ab21a925665ac9aad27f8ab889d431baf0b4bf99daa7b27b1babb'
AND (
token = 'y5hu8YFk5K3HRYCQrf142J2p9Q3x+SNTpmjriafR+rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)