UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7xrd1kilvG+o2F0HMCfTu2SCpPEiIx/xgFhX2LtZU0='
WHERE
key_id = '54ee7bf4b6249182bf7894f18393f1351226c51887822b3c93cf1c4203123f2d'
AND (
token = 'i7xrd1kilvG+o2F0HMCfTu2SCpPEiIx/xgFhX2LtZU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)