UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+gTA5WkBpT01SVa5V8ORuYGtK9xc5t6zuX3Mm7rnRew='
WHERE
key_id = '02d1d50efd4517664513257770df0f8f057f33f3b9ab281a66d90ea6a3718114'
AND (
token = '+gTA5WkBpT01SVa5V8ORuYGtK9xc5t6zuX3Mm7rnRew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)