UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFkD0x36dEGXtkLzeVAtP4dwqr2Al9RjNrEuexJurqI='
WHERE
key_id = '7a059d95e357859ddeee67fb50e19b25e6b44409a157546223f2edf6bb63c892'
AND (
token = 'ZFkD0x36dEGXtkLzeVAtP4dwqr2Al9RjNrEuexJurqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)