UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eDr336mPfbNRiZ609b01stWeU3ikoljW5biG9sCM9dU='
WHERE
key_id = '187f2b92523c6e2e688a3497b349447f832b802ef5e9e4fed5f372394fcf1cd7'
AND (
token = 'eDr336mPfbNRiZ609b01stWeU3ikoljW5biG9sCM9dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)