UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bN4T1y5uiilNf7ccLo6ZMJH34ulXEs/MMQuSKHhuhqw='
WHERE
key_id = 'd808cf4c2a18db4e09653e671bcd4562239809f474e424734f4787a51da8e35d'
AND (
token = 'bN4T1y5uiilNf7ccLo6ZMJH34ulXEs/MMQuSKHhuhqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)