UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apLeA4pOU2xbuwY2fVYlh3elaioAxb7ZVCy7N5yl7k8='
WHERE
key_id = '5d27e4d8c6e8ddb392d464782b61122472ba795d2e3916505bbb9f82506bf108'
AND (
token = 'apLeA4pOU2xbuwY2fVYlh3elaioAxb7ZVCy7N5yl7k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)